﻿// Jinx AJAX Framework
// Copyright (C) 2008 Blake Hegerle
//
// This program is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
//
// This program is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with this program.  If not, see <http://www.gnu.org/licenses/>.

using System;
using System.Collections.Generic;
using System.Data;
using System.Collections;

namespace Formality.Game.Database
{
    public static class CommandExtension
    {
        public static void Execute(this string CommandText, object Params)
        {
            using (var C = ConnectionFactory.GetOpenConnection())
            using (var Cmd = C.CreateCommand())
            {
                Sql(Cmd, CommandText, Params);

                Cmd.ExecuteNonQuery();
            }
        }

        public static T ExecuteScalar<T>(this string CommandText, object Params)
        {
            using (var C = ConnectionFactory.GetOpenConnection())
            using (var Cmd = C.CreateCommand())
            {
                Sql(Cmd, CommandText, Params);

                return (T) Cmd.ExecuteScalar();
            }
        }

        public static IEnumerable<T> ExecuteReader<T>(this string CommandText, object Params, Func<IDataReader, T> Map)
        {
            using (var C = ConnectionFactory.GetOpenConnection())
            using (var Cmd = C.CreateCommand())
            {
                Sql(Cmd, CommandText, Params);

                using (var Reader = Cmd.ExecuteReader())
                    while (Reader.Read())
                        yield return Map(Reader);
            }
        }

        private static void Sql(IDbCommand Cmd, string CommandText, object Params)
        {
            Cmd.CommandText = CommandText;

            foreach (var Param in Params.GetType().GetProperties())
            {
                var DbParam = Cmd.CreateParameter();

                DbParam.ParameterName = "@" + Param.Name;
                DbParam.Value = Param.GetValue(Params, null);
                DbParam.DbType = DbType.String;

                Cmd.Parameters.Add(DbParam);
            }
        }
    }
}